Smartsheet User 99 ✭✭✭

• Activity
• Discussions5
• Comments31

• Re: Birthday/Anniversary Formula & Reminders

  Smartsheet User 99

  04/08/22
  You're welcome, let me know if you want to calculate the number of days before their anniversary or bday, and if you need help setting up automation.
  1 ·

• Re: Birthday/Anniversary Formula & Reminders

  Smartsheet User 99

  04/08/22
  Here is the formula to keep the Date and Month of the Hire, but adding current year to it =DATE(YEAR(TODAY()), MONTH([Company Date of Hire]@row), DAY([Company Date of Hire]@row)) Here is the formula …
  3 ·